Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_611

R_611

Service

PerfService

ServID

 

 

R_660

R_660

Event

PerfService

EventID

 

 

R_906

R_906

Frequency

PerfService

FrequencyID

 

 

R_1148

R_1148

Patient

Reservation

PersonID

 

 

R_1149

R_1149

ReservationStatus

LReservationStatus

ReservationStatusID

 

 

R_1150

R_1150

ReservationStatus

ReservationStatusText

ReservationStatusID

 

 

R_1151

R_1151

Reservation

Event

ReservationID

 

 

R_1152

R_1152

Reservation

PerfService

ReservationID

 

 

R_1153

R_1153

Reservation

Reservation

Res_ReservationID

 

 

R_1154

R_1154

TimePattern

Reservation

TimePatternID

 

 

R_1156

R_1156

TimePattern

TimePattern

Tim_TimePatternID

 

 

R_1157

R_1157

TimePattern

TimePatternTimeSlot

TimePatternID

 

 

R_1158

R_1158

Frequency

TimePatternTimeSlot

FrequencyID

 

 

R_1159

R_1159

TimeSlotType

TimePatternTimeSlot

TimeslotTypeID

 

 

R_1160

R_1160

TimePattern

LServiceTimePattern

TimePatternID

 

 

R_1161

R_1161

LServiceTimePattern

LServTimePatternVisitType

ServID; TimePatternID

 

 

R_1162

R_1162

Service

Reservation

ServID

 

 

R_1163

R_1163

Service

LServiceTimePattern

ServID

 

 

R_1164

R_1164

VisitType

LServTimePatternVisitType

VisitTypeID

 

 

R_1165

R_1165

VisitType

Reservation

VisitTypeID

 

 

R_1166

R_1166

Service

LServiceVisitType

ServID

 

 

R_1167

R_1167

VisitType

LServiceVisitType

VisitTypeID

 

 

R_1168

R_1168

Service

LServiceTimePatternTimeslot

ServID

 

 

R_1169

R_1169

TimePatternTimeSlot

LServiceTimePatternTimeslot

TimePatternTimeSlotID

 

 

R_1171

R_1171

TimePatternTimeSlot

LTimePatternTimeSlotLanguage

TimePatternTimeSlotID

 

 

R_1173

R_1173

MedResource

TimePattern

MedResourceID

 

 

R_1174

R_1174

MedResource

MedResourceAddOns

MedResourceID

 

 

R_1175

R_1175

Sex

MedResourceAddOns

Sex

 

 

R_1178

R_1178

Reservation

LReservationStatus

ReservationID

 

 

R_1188

R_1188

TimePatternTimeSlot

Reservation

TimePatternTimeSlotID

 

 

R_1191

R_1191

Sex

TimePatternTimeSlot

Sex

 

 

R_1446

R_1446

VisitCancelReason

VisitCancelReasonText

VisitCancelReasonID

 

 

R_1448

R_1448

VisitCancelReason

LReservationStatus

VisitCancelReasonID

 

 

R_1522

R_1522

TimePatternTimeSlot

TimePatternTimeSlot

Tim_TimePatternTimeSlotID

 

 

R_1553

R_1553

TimePattern

TimeStampLock

TimePatternID

 

 

R_1721

R_1721

MedResource

Reservation

MedResourceID

 

 

R_1740

R_1740

LServiceTimePatternTimeslot

LServiceTPTimeSlotDuration

LServiceTimePatternTimeslotID

 

 

R_1741

R_1741

VisitType

LServiceTPTimeSlotDuration

VisitTypeID

 

 

R_1951

R_1951

ReservationStatus

Reservation

ReservationStatusID

 

 

R_8070

R_8070

PriceList

PerfService

PriceListID

 

 

R_8250

R_8250

TimeStamp

TimeStampText

TimeStampID

 

 

R_8251

R_8251

TimeStamp

LPerfServiceTimeStamp

TimeStampID

 

 

R_8252

R_8252

Person

LPerfServiceTimeStamp

PersonID

 

 

R_8253

R_8253

PerfService

LPerfServiceTimeStamp

PerfServiceID

 

 

R_8254

R_8254

TimeStampType

TimeStampTypeText

TimeStampTypeID

 

 

R_8255

R_8255

TimeStampType

TimeStamp

TimeStampTypeID

 

 

R_8470

R_8470

TimePatternTimeSlot

LTimePatternTimeSlotColor

TimePatternTimeSlotID

 

 

R_8540

R_8540

Person

LPatientDayInterval

PersonID

 

 

R_8541

R_8541

DayInterval

LPatientDayInterval

DayIntervalID

 

 

R_8542

R_8542

Service

LPatientDayInterval

ServID

 

 


2